Stored Procedures [dbo].[asi_CreateGLTransLine]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@acctKeyuniqueidentifier16
@amountdecimal(18,4)9
@invoiceKeyuniqueidentifier16
@paymentKeyuniqueidentifier16
@invoiceLineKeyuniqueidentifier16
@descriptionvarchar(50)50
@prodKeyuniqueidentifier16
@finEntityKeyuniqueidentifier16
@transDatedatetime8
@deferralTermsKeyuniqueidentifier16
@deferredIncAcctKeyuniqueidentifier16
@glEntryTypenvarchar(50)100
@journalTypeint4
SQL Script
CREATE  PROCEDURE [dbo].[asi_CreateGLTransLine]
@acctKey uniqueidentifier,
@amount decimal(18,4),
@invoiceKey uniqueidentifier,
@paymentKey uniqueidentifier,
@invoiceLineKey uniqueidentifier,
@description varchar(50),
@prodKey uniqueidentifier,
@finEntityKey uniqueidentifier,
@transDate datetime,
@deferralTermsKey uniqueidentifier,
@deferredIncAcctKey uniqueidentifier,
@glEntryType nvarchar(50),
@journalType int


AS
BEGIN
    INSERT #tmpTransLine(AccountKey, Amount, InvoiceKey, PaymentKey, Description, ProductKey, FinEntityKey,
    TransDate, DeferralTermsKey, DeferredIncomeGLAccountKey, InvoiceLineKey, GLEntryType, JournalEntryTypeCode)
    VALUES (@acctKey, @amount, @invoiceKey, @paymentKey, @description , @prodKey, @finEntityKey,
    @transDate, @deferralTermsKey, @deferredIncAcctKey, @invoiceLineKey, @glEntryType, @journalType)
END

GO
Uses